James Keuning — Smartsheet Community

Skip to content

Overview

Overview
Roles	Member
Badges	22

About Me

About Me
Country	United States
How I Use Smartsheet	We use Smartsheet to support various functions in a law firm. We started using it as the PMIS for our PMO but have expanded into supporting lawyers and their clients. The collaborators are free model is the feature that attracted me to Smartsheet, but after several years, I have no reason to leave. We use Data Shuttle to move data in and out of our various systems, and along with Power Automate and Power BI, we find that it can do most of what we need.

Analytics

492

Posts

626

Visits

935

Points

Oct 5, 2020

Join Date

Feb 28, 2025

Last Active

Re: How to show blank where no data is, when using =MAX(0, NETWORKDAYS(TODAY(), End@row))

James Keuning

05/06/22

iferror(MAX(0, NETWORKDAYS(TODAY(), End@row)),"")

1 ·
Re: Including child rows in filters

James Keuning

04/20/22

@Brian Pitts It should work in other columns. The INDEX basically says, "Make a set of values that is comprised of all of the ANCESTORS for this field. And then the "1" part of the IND…

2 ·
Re: Strange Formula Behavior

James Keuning

04/29/22

I have one like this too. A pretty complicated budget sheet that shows errors while editing, and after saving, but which resolves when I refresh. It makes me nervous every time I encounter it. So, no…

1 ·
Re: VLOOKUP with multiple criteria

James Keuning

04/27/22

When I have been faced with this problem I create a helper column in both sheets, and concatenate the two fields. In your case, I would call the field DATE DESC and it would be something like DATE@ro…

1 ·
Re: Can I show my users if they are logged in when using a form?

James Keuning

04/23/22

@Jeff Reisman Hi Jeff, just commenting on using Firefox for testing with your unlicensed user - you can also use a create a profile in Chrome for that purpose. The new chrome profile won't have your …

1 ·